Example: Find registered members by city
This query extracts Dallas individual members who registered for an event.
- Browse to IQA.
- Select Query from the drop-down list and select New.
- Select sources:
- Browse to the Common folder containing business objects.
- Select Contact and CsActivity.
- Define the filtering rules:
- Select the Filters tab.
- Select Mode: Advanced
- Operator: Where Not
- Filter on CsActivity.Activity Type.
- Property: CsActivity.Activity Type
- Comparison: Equal
- Value: MEETING
- Add the filter.
- Select Add Filter.
- Select And from the drop-down list.
- Filter on Contact.City.
- Property: Contact.City
- Comparison: Equal
- Value: DALLAS
- Add the filter.
- Filter on Contact.MemberType.
- Property: Contact.MemberType
- Comparison: Equal
- Value: Individual Member
- Add the filter.
- Define the columns to display in the output:
- Select the Display tab.
- Select the following columns:
- Using the Order drop-down list, assign:
- Contact.Id Order 1
- Contact.City Order 2
- Contact.MemberType Order 3
- CsActivity.Activity Type Order 4
- Specify the sorting priority:
- Select the Sorting tab.
- Sort the results by ContactId.
- Add your selection.
- Save your settings.
- Run the query.